<?php

class TrattamentoController extends Controller {
	/**
	 * @var string the default layout for the views. Defaults to '//layouts/column2', meaning
	 * using two-column layout. See 'protected/views/layouts/column2.php'.
	 */
	public $layout = '//layouts/normalHeader';

	/**
	 * @return array action filters
	 */
	public function filters() {
		return array('accessControl',  // perform access control for CRUD operations
		);
	}

	/**
	 * Specifies the access control rules.
	 * This method is used by the 'accessControl' filter.
	 * @return array access control rules
	 */
	public function accessRules() {
		return array( array('allow', // allow all users to perform 'index' and 'view' actions
		'actions' => array('create', 'update', 'delete', 'admin', 'ajaxSearch', 'view'), 'users' => array('*'), ), array('deny', // deny all users
		'users' => array('*'), ), );
	}

	/**
	 * Displays a particular model.
	 * @param integer $id the ID of the model to be displayed
	 */
	public function actionView($id) {
		$this -> render('view', array('model' => $this -> loadModel($id), ));
	}

	/**
	 * Creates a new model.
	 * If creation is successful, the browser will be redirected to the 'view' page.
	 */
	public function actionCreate() {
		$model = new Trattamento;

		// Uncomment the following line if AJAX validation is needed
		// $this->performAjaxValidation($model);

		if (isset($_POST['Trattamento'])) {
			$model -> attributes = $_POST['Trattamento'];
			if ($model -> save())
				$this -> redirect(array('admin', 'id' => $model -> id));
		}

		$this -> render('create', array('model' => $model, ));
	}

	/**
	 * Updates a particular model.
	 * If update is successful, the browser will be redirected to the 'view' page.
	 * @param integer $id the ID of the model to be updated
	 */
	public function actionUpdate($id) {
		$model = $this -> loadModel($id);

		// Uncomment the following line if AJAX validation is needed
		// $this->performAjaxValidation($model);

		if (isset($_POST['Trattamento'])) {
			$model -> attributes = $_POST['Trattamento'];
			if ($model -> save())
				$this -> redirect(array('admin', 'id' => $model -> id));
		}

		$this -> render('update', array('model' => $model, ));
	}

	/**
	 * Deletes a particular model.
	 * If deletion is successful, the browser will be redirected to the 'admin' page.
	 * @param integer $id the ID of the model to be deleted
	 */
	public function actionDelete($id) {
		if (Yii::app() -> request -> isPostRequest) {
			// we only allow deletion via POST request
			$this -> loadModel($id) -> delete();

			// if AJAX request (triggered by deletion via admin grid view), we should not redirect the browser
			if (!isset($_GET['ajax']))
				$this -> redirect(isset($_POST['returnUrl']) ? $_POST['returnUrl'] : array('admin'));
		} else
			throw new CHttpException(400, 'Invalid request. Please do not repeat this request again.');
	}

	/**
	 * Lists all models.
	 */
	public function actionIndex() {
		$dataProvider = new CActiveDataProvider('Trattamento');
		$this -> render('index', array('dataProvider' => $dataProvider, ));
	}

	/**
	 * Manages all models.
	 */
	public function actionAdmin() {
		$model = new Trattamento('search');
		$model -> unsetAttributes();
		// clear any default values
		if (isset($_GET['Trattamento']))
			$model -> attributes = $_GET['Trattamento'];

		$this -> render('admin', array(
			'model' => $model,
			'numeroTrattamenti' => $model -> count() 
			)
		);
	}

	/**
	 * Get search term
	 */
	public function actionAjaxSearch() {
		$iniziali = $_GET['term'];

		if (isset($iniziali) && $iniziali != '') {

			$connection = Yii::app() -> db;
			$command = $connection -> createCommand('SELECT nome,Trattamenti.id,durata FROM Trattamenti  WHERE nome LIKE \'%' . $_GET['term'] . '%\'');

			$dataReader = $command -> query();

			$risultati = array();

			foreach ($dataReader as $row) {
				array_push($risultati, array('label' => $row['nome'], 'value' => $row['id'] . '|' . ($row['durata'] / 15)));
			}

			echo CJSON::encode($risultati);
		}
		Yii::app() -> end();
	}

	/**
	 * Returns the data model based on the primary key given in the GET variable.
	 * If the data model is not found, an HTTP exception will be raised.
	 * @param integer the ID of the model to be loaded
	 */
	public function loadModel($id) {
		$model = Trattamento::model() -> findByPk($id);
		if ($model === null)
			throw new CHttpException(404, 'The requested page does not exist.');
		return $model;
	}

	/**
	 * Performs the AJAX validation.
	 * @param CModel the model to be validated
	 */
	protected function performAjaxValidation($model) {
		if (isset($_POST['ajax']) && $_POST['ajax'] === 'trattamento-form') {
			echo CActiveForm::validate($model);
			Yii::app() -> end();
		}
	}

}
